Hi,

I am getting below OLEDB error for SCOM Management server please suggest for solution..

is anyone can suggest solution for this alert.

For this issue, you can use the following steps:

1. Clear the Health service management pack cache on the Service Manager management server.
2. After you have cleared the cache, remove the Service Manager Management Pack from Operations Manager, and then re-import it.
3. Override the discovery time.

Also you can check Answer of Eric for same issue

https://social.technet.microsoft.com/Forums/systemcenter/en-US/eff1243e-1348-4bd5-b21d-a5d912aeeec9/oledb-module-encountered-a-failure

ANd if it is not related to service manager integration, check the database access. the error code is an access denied code. It could be the management server action account does not have access to the backend databases for SCOM. If you need to check the rights you could for instance check for a technet article about moving the SCOM databases to another server. those articles have references to the rights set for service accounts to the databases.

hi Bob,

Can you please share the Required rights that i have to check for the Management server action account in DB step by step...

Hi Mai ,

I haven`t found Service Manager Management Pack installed on my SCOM 2012 R2..

please suggest.

Hi Shailendra,

Check logs on your SQLs, if it's any errors there.

The SCOM 2012 Security Accounts Matrix:

http://blogs.technet.com/b/manageabilityguys/archive/2013/05/03/scom-2012-sp1-security-accounts-matrix.aspx

Thats a good post indeed.
And otherwise check out these two posts, which somewhere a few steps down list some rights to check:
https://technet.microsoft.com/en-us/library/hh278848.aspx
https://technet.microsoft.com/en-us/library/hh268492.aspx

Hi There,

Is this alert frequent or does it appear rarely ?

Issues can be of permissions or connectivity with the Ops DB.